package com.example.excel.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.*;
import lombok.Data;
import lombok.experimental.Accessors;
import lombok.experimental.FieldNameConstants;
import org.apache.poi.ss.usermodel.BorderStyle;

/**
 * description :
 * author :song
 * create :2021-12-15 09:30:00
 */
@Data
@Accessors(chain = true)
@FieldNameConstants
@HeadRowHeight(value = 25)
@ContentRowHeight(value = 18)
@ColumnWidth(value = 20)
@HeadStyle(fillBackgroundColor = 64)
@HeadFontStyle(bold = false)
@ContentStyle(borderTop = BorderStyle.THIN, borderLeft = BorderStyle.THIN, borderRight = BorderStyle.THIN, borderBottom = BorderStyle.THIN)
public class DataStatisticsEasyExcel {

    @ExcelProperty(value = {"温州市数据统计表"}, index = 0)
    private String street;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 1)
    private String community;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 2)
    private String cooperation;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 3)
    private String cjcgZs;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 4)
    private String cjcgXz;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 5)
    private String cjgzZs;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 6)
    private String cjgzXz;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 7)
    private String zczyZs;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 8)
    private String zczyXz;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 9)
    private String lwygZs;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 10)
    private String lwygXz;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 11)
    private String jzbzZs;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 12)
    private String jzbzXz;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 13)
    private String yzglZs;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 14)
    private String yzglXz;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 15)
    private String jcllzZs;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 16)
    private String jcllzXz;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 17)
    private String jdydtZs;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 18)
    private String jdydtXz;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 19)
    private String wsgkZs;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 20)
    private String wsgkXz;

    @ExcelProperty(value = {"温州市数据统计表"}, index = 21)
    private String save;
}
